In [105]:
what is favorite Breed probability?
what the high rate Breed probability?
which year has high tweets for WeRateDogs?
which month have high activity at WeRateDogs?
the best 5 dogs at best breed probability?
according to highest dog stage,
1-how many tweeter ?
2-how many tweets?
3-which high rate?
4-how many like?
5-how many retweets?
6-how many dogs name in same stage?
#get data frame for golden_retriever
| tweet_id | tweet | rating_numerator | rating_denominator | name | dog_stage | year | month | day | retweet_count | ... | jpg_url | first_prediction | first_confidence | first_dog | second_prediction | second_confidence | second_dog | third_prediction | third_confidence | third_dog | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1433 | 779834332596887552 | This is Scout. He really wants to kiss himself... | 11.0 | 10.0 | Scout | NaN | 2016 | 9 | 25 | 8237 | ... | https://pbs.twimg.com/media/CtKHLuCWYAA2TTs.jpg | golden_retriever | 0.993830 | True | cocker_spaniel | 0.003143 | True | Great_Pyrenees | 0.000917 | True |
| 176 | 669216679721873412 | This is Clarq. He's a golden Quetzalcoatl. Cla... | 8.0 | 10.0 | Clarq | NaN | 2015 | 11 | 24 | 422 | ... | https://pbs.twimg.com/media/CUmJBS5WUAAKtrP.jpg | golden_retriever | 0.992758 | True | Irish_setter | 0.003379 | True | Saluki | 0.001230 | True |
| 1046 | 715680795826982913 | This is Zeus. He's downright fabulous. 12/10 h... | 12.0 | 10.0 | Zeus | NaN | 2016 | 3 | 31 | 1813 | ... | https://pbs.twimg.com/media/Ce6b4MPWwAA22Xm.jpg | golden_retriever | 0.990715 | True | Labrador_retriever | 0.002228 | True | chow | 0.001197 | True |
3 rows × 22 columns
#### first the best Breed probability (Golden Retriever)with high confidence
#sceond the best Breed probability (Golden Retriever) with high confidence
#Third the best Breed probability (Golden Retriever) with high confidence
#highest Dogs Stage accourding to favorite counts
# Tweeter user increase in 2016 and cringe in 2017
year 2016 7.089651e+20 2015 4.406337e+20 2017 3.011397e+20 Name: tweet_id, dtype: float64
highset_favorite=master_clean.sort_values('favorite_count',ascending=False);
highset_favorite=highset_favorite[['tweet_id','favorite_count','jpg_url','dog_stage','first_prediction']]
highset_favorite.head(2)
| tweet_id | favorite_count | jpg_url | dog_stage | first_prediction | |
|---|---|---|---|---|---|
| 1664 | 822872901745569793 | 132810 | https://pbs.twimg.com/media/C2tugXLXgAArJO4.jpg | puppo | Lakeland_terrier |
| 1201 | 744234799360020481 | 131075 | https://pbs.twimg.com/ext_tw_video_thumb/74423... | doggo | Labrador_retriever |
# the first high favorte for dog stage puppo
# rating per month count
##we can see that rating increase during jan,nov, dec (winter months)
##rating per favorite count
# most of pepole give high rate and give high like that mean most of them like his dog too much
# Important Data statistic for WeRateDogs
| rating_numerator | retweet_count | favorite_count | first_confidence | second_confidence | third_confidence | |
|---|---|---|---|---|---|---|
| count | 1971.000000 | 1971.000000 | 1971.000000 | 1971.000000 | 1.971000e+03 | 1.971000e+03 |
| mean | 10.500863 | 2784.449518 | 8949.106545 | 0.594558 | 1.345850e-01 | 6.016556e-02 |
| std | 2.243487 | 4697.662893 | 12267.799790 | 0.272126 | 1.010527e-01 | 5.094156e-02 |
| min | 0.000000 | 16.000000 | 81.000000 | 0.044333 | 1.011300e-08 | 1.740170e-10 |
| 25% | 10.000000 | 628.500000 | 1997.000000 | 0.363091 | 5.339800e-02 | 1.608055e-02 |
| 50% | 11.000000 | 1367.000000 | 4147.000000 | 0.587764 | 1.173970e-01 | 4.944380e-02 |
| 75% | 12.000000 | 3239.000000 | 11402.500000 | 0.847827 | 1.955655e-01 | 9.153815e-02 |
| max | 17.760000 | 79515.000000 | 132810.000000 | 1.000000 | 4.880140e-01 | 2.734190e-01 |
name Bo 185922 Charlie 115468 Zoey 113581 Lucy 110523 Duddles 107956 Quite 107309 Stephan 107015 Jamesy 106827 Penny 102986 Stanley 99345 Name: favorite_count, dtype: int64
## relation between retweet count over time with favorite
| tweet_id | tweet | rating_denominator | favorite_count | retweet_count | name | first_prediction | first_confidence | first_dog | second_prediction | second_confidence | second_dog | third_prediction | third_confidence | third_dog | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dog_stage | |||||||||||||||
| pupper | 201 | 201 | 201 | 201 | 201 | 122 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201 |
| doggo | 63 | 63 | 63 | 63 | 63 | 38 | 63 | 63 | 63 | 63 | 63 | 63 | 63 | 63 | 63 |
| puppo | 22 | 22 | 22 | 22 | 22 | 15 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 |
| doggopupper | 8 | 8 | 8 | 8 | 8 | 5 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |
| floofer | 7 | 7 | 7 | 7 | 7 | 5 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| doggofloofer | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| doggopuppo | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |